Release 10.1A: OpenEdge Data Management:
SQL Reference

Numeric arithmetic expressions

Numeric arithmetic expressions compute a value using addition, subtraction, multiplication, and division operations on numeric literals and expressions that evaluate to any numeric data type.

This is the syntax for a numeric arithmetic expression:

Syntax

[ + | - ] { numeric_literal | numeric_expr }     [ { + | - | * | / } numeric_arith_expr ]

+ | -

Unary operators.

numeric_literal

Number value.

numeric_expr

Evaluates to a numeric data type.

+ | - | * | /

Operators for addition, subtraction, multiplication, and division. SQL evaluates numeric arithmetic expressions in the following order:

Unary plus or minus.
Expressions in parentheses.
Multiplication and division, from left to right.
Addition and subtraction, from left to right.